CREATE TABLE fips55 (                    
          STATE int(11) default NULL,            
          PLACE int(11) default NULL,            
          STATE_ALPHA varchar(2) NOT NULL,              
          CLASS varchar(2) default NULL,         
          PLACE_NAME varchar(52) NOT NULL,       
          COUNTY int(11) NOT NULL,               
          COUNTY_NAME varchar(22) default NULL,       
          ZIP int(11) default NULL,              
          ZIP_RANGE int(11) default NULL     
        ) ENGINE=MyISAM DEFAULT CHARSET=latin1     ;

CREATE TABLE tiger_01 (                                             
            TLID int(11) NOT NULL,                                            
            FRLONG int(11) NOT NULL,                                          
            FRLAT int(11) NOT NULL,                                           
            TOLONG int(11) NOT NULL,                                          
            TOLAT int(11) NOT NULL,                                           
            FRADDL int(11) default NULL,                                      
            TOADDL int(11) default NULL,                                      
            FRADDR int(11) default NULL,                                      
            TOADDR int(11) default NULL,                                      
            ZIP int(11) default NULL,                                         
            ZIP3 int(11) default NULL,                                        
            FENAME varchar(30) default NULL,                                  
            FETYPE varchar(4) default NULL,                                   
            FEDIRP varchar(2) default NULL,                                   
            FEDIRS varchar(2) default NULL,                                   
            STATE int(11) default NULL,                                       
            COUNTY int(11) default NULL,                                      
            PLACE int(11) default NULL,                                       
            CFCC varchar(3) default NULL                                    
          ) ENGINE=MyISAM DEFAULT CHARSET=latin1     ;
          
CREATE TABLE tiger_02 (               
            RT varchar(1) default NULL,         
            VER int(11) default NULL,           
            TLID int(11) default NULL,          
            RTSQ int(11) default NULL,          
            LONG1 int(11) default NULL,         
            LAT1 int(11) default NULL,          
            LONG2 int(11) default NULL,         
            LAT2 int(11) default NULL,          
            LONG3 int(11) default NULL,         
            LAT3 int(11) default NULL,          
            LONG4 int(11) default NULL,         
            LAT4 int(11) default NULL,          
            LONG5 int(11) default NULL,         
            LAT5 int(11) default NULL,          
            LONG6 int(11) default NULL,         
            LAT6 int(11) default NULL,          
            LONG7 int(11) default NULL,         
            LAT7 int(11) default NULL,          
            LONG8 int(11) default NULL,         
            LAT8 int(11) default NULL,          
            LONG9 int(11) default NULL,         
            LAT9 int(11) default NULL,          
            LONG10 int(11) default NULL,        
            LAT10 int(11) default NULL          
          ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE tiger_types (             
               TYPE_ID int(11) NOT NULL,            
               TIGER_TYPE varchar(4) default NULL,  
               LONG_NAME varchar(15) default NULL   
             ) ENGINE=MyISAM DEFAULT CHARSET=latin1   ;      
             
             
             
LOAD DATA LOCAL INFILE '<t1path>'
INTO TABLE TIGER_01
FIELDS
   TERMINATED BY ','
   OPTIONALLY ENCLOSED BY '"'
LINES
   TERMINATED BY '\r\n'
;
LOAD DATA LOCAL INFILE '<FIPSpath>'
INTO TABLE FIPS55
FIELDS
   TERMINATED BY ','
   OPTIONALLY ENCLOSED BY '"'
LINES
   TERMINATED BY '\r\n'
;

                                   
CREATE INDEX IDX_NAME on TIGER_01  (FENAME,ZIP3,FETYPE,ZIP,FEDIRP,FEDIRS); 
CREATE INDEX IDX_TOLAT on TIGER_01 (TOLAT);                                          
CREATE INDEX IDX_FRLAT on TIGER_01 (FRLAT);  
CREATE INDEX IDX_T2_TLID on TIGER_02 (TLID);     